IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'tblGuy_Info'
          AND COLUMN_NAME = 'BuyerBranchCode'
)
    ALTER TABLE dbo.tblGuy_Info ADD BuyerBranchCode VARCHAR(MAX) NULL;


IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[STIGetInfoAcc]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[STIGetInfoAcc]